excel超链接打开文件夹
You can use Excel hyperlinks to navigate through a workbook, go to web pages, open other Excel files, and even open PDF files. However, if you try to use an Excel hyperlink to run command files, you'll run into problems. Until now! Here's how J.Woolley uses hyperlinks, with a background macro, to avoid those problems – and a other problems too. He also found a strange hyperlink bug.
您可以使用Excel超链接浏览工作簿,转到网页,打开其他Excel文件,甚至打开PDF文件。 但是,如果您尝试使用Excel超链接来运行命令文件,则会遇到问题。 到现在! 这就是J.Woolley如何使用带有背景宏的超链接来避免这些问题以及其他问题。 他还发现了一个奇怪的超链接错误。
超链接命令文件问题 (Hyperlink Command File Problems)
Websites and Excel files open nicely (usually), if you click a hyperlink in a worksheet. With command files, you'll run into issues, such as:
如果您单击工作表中的超链接,则网站和Excel文件将正常打开(通常)。 使用命令文件,您会遇到一些问题,例如:
- Dialog boxes appear, and you have to click an OK or Cancel button 出现对话框,您必须单击“确定”或“取消”按钮
- You can't add command line arguments in the hyperlink 您不能在超链接中添加命令行参数
- Shell window flashes with a long or complex script file (cmd or vbs) Shell窗口使用长脚本或复杂脚本文件(cmd或vbs)闪烁
地址错误问题 (Bad Address Problems)
Even with file types that should open from a hyperlink, you'll see an error message if there is a problem with the address. Here's what appears if I misspell Contextures in a cell, and then click the link that is automatically created.
即使应该从超链接打开的文件类型,如果地址有问题,您也会看到错误消息。 如果我在单元格中拼写了Contextures,然后单击自动创建的链接,则会出现以下内容。
The message says, "Unable to open http://www.contexturs.com/. Cannot locate the Internet server or proxy server.'
消息显示,“无法打开http://www.contexturs.com/。无法找到Internet服务器或代理服务器。”